
if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_ProductAttibute') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_ProductAttibute
END
GO
CREATE VIEW V_ProductAttibute
AS
SELECT B.Guid,A.Name,a.AttrValue,B.AtrributeValue,B.AttributePrice,B.ProductGuid
From ShopNum1_ProductAttribute A 
INNER JOIN ShopNum1_ProductAttributeValue B ON a.Guid=b.ProductAttributeGuid
WHERE B.IsDeleted=0